/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80030
 Source Host           : localhost:3306
 Source Schema         : oauth_db

 Target Server Type    : MySQL
 Target Server Version : 80030
 File Encoding         : 65001

 Date: 08/09/2024 22:15:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(255) NOT NULL,
  `resource_ids` varchar(255) DEFAULT NULL,
  `client_secret` varchar(255) DEFAULT NULL,
  `scope` varchar(255) DEFAULT NULL,
  `authorized_grant_types` varchar(255) DEFAULT NULL,
  `web_server_redirect_uri` varchar(255) DEFAULT NULL,
  `authorities` varchar(255) DEFAULT NULL,
  `access_token_validity` int DEFAULT NULL,
  `refresh_token_validity` int DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` (`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES ('ABC', 'demo-app', '$2a$10$LaY9MNGFaInbMTx1nhaVXuGwyqMmNExCYoGZK/FJL2G91SIfVnXp2', 'read,write', 'client_credentials,authorization_code,password,refresh_token,implicit', 'http://www.baidu.com', 'user', 7199, 2592000, NULL, 'true');
COMMIT;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `params` longtext,
  `ip` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1807605996596527106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_log
-- ----------------------------
BEGIN;
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452875323237588993, 'anonymousUser', '获取验证码', 'com.yl.controller.AuthController.captcha', '[]', '0:0:0:0:0:0:0:1', '2021-10-26 13:50:45', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452875323237588994, 'anonymousUser', '获取验证码', 'com.yl.controller.AuthController.captcha', '[]', '0:0:0:0:0:0:0:1', '2021-10-26 13:50:45', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452875326525923330, 'anonymousUser', '获取验证码', 'com.yl.controller.AuthController.captcha', '[]', '0:0:0:0:0:0:0:1', '2021-10-26 13:50:46', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452875364333379585, 'admin', '登陆成功', 'login', NULL, '0:0:0:0:0:0:0:1', '2021-10-26 13:50:55', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452877860032266242, 'anonymousUser', '获取验证码', 'com.yl.controller.AuthController.captcha', '[]', '0:0:0:0:0:0:0:1', '2021-10-26 14:00:50', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452877864566308865, 'anonymousUser', '获取验证码', 'com.yl.controller.AuthController.captcha', '[]', '0:0:0:0:0:0:0:1', '2021-10-26 14:00:51', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1452877894664634370, 'admin', '登陆成功', 'login', NULL, '0:0:0:0:0:0:0:1', '2021-10-26 14:00:58', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807598135455830017, 'anonymousUser', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:12:34', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807598637157502977, 'admin', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:14:33', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807600970583011330, 'admin', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:23:50', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807604026422902786, 'admin', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:35:58', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807604271118635009, 'admin', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:36:57', NULL, NULL);
INSERT INTO `t_log` (`id`, `username`, `operation`, `method`, `params`, `ip`, `create_time`, `update_time`, `status`) VALUES (1807605996596527105, 'admin', '登陆', 'com.yl.controller.AuthController.login', '[{\"password\":\"111111\",\"username\":\"admin\"}]', '192.168.0.136', '2024-07-01 10:43:48', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(64) NOT NULL,
  `path` varchar(255) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(255) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `component` varchar(255) DEFAULT NULL,
  `type` int NOT NULL COMMENT '类型     0：目录   1：菜单   2：按钮',
  `icon` varchar(32) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `status` int NOT NULL,
  `is_del` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1452877598907482114 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (1, 0, '系统管理', '', 'sys:manage', '', 0, 'el-icon-s-operation', 1, '2021-01-15 18:58:18', '2021-01-15 18:58:20', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (2, 1, '用户管理', '/sys/users', 'sys:user:list', 'sys/User', 1, 'el-icon-s-custom', 1, '2021-01-15 19:03:45', '2021-01-15 19:03:48', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (3, 1, '角色管理', '/sys/roles', 'sys:role:list', 'sys/Role', 1, 'el-icon-rank', 2, '2021-01-15 19:03:45', '2021-01-15 19:03:48', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (4, 1, '菜单管理', '/sys/menus', 'sys:menu:list', 'sys/Menu', 1, 'el-icon-menu', 3, '2021-01-15 19:03:45', '2021-01-15 19:03:48', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (5, 0, '系统工具', '', 'sys:tools', NULL, 0, 'el-icon-s-tools', 2, '2021-01-15 19:06:11', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (6, 5, '数字字典', '/sys/dicts', 'sys:dict:list', 'sys/Dict', 1, 'el-icon-s-order', 1, '2021-01-15 19:07:18', '2021-01-18 16:32:13', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (7, 3, '添加角色', '', 'sys:role:save', '', 2, '', 1, '2021-01-15 23:02:25', '2021-01-17 21:53:14', 0, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (9, 2, '添加用户', NULL, 'sys:user:save', NULL, 2, NULL, 1, '2021-01-17 21:48:32', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (10, 2, '修改用户', NULL, 'sys:user:update', NULL, 2, NULL, 2, '2021-01-17 21:49:03', '2021-01-17 21:53:04', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (11, 2, '删除用户', NULL, 'sys:user:delete', NULL, 2, NULL, 3, '2021-01-17 21:49:21', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (12, 2, '分配角色', NULL, 'sys:user:role', NULL, 2, NULL, 4, '2021-01-17 21:49:58', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (13, 2, '重置密码', NULL, 'sys:user:repass', NULL, 2, NULL, 5, '2021-01-17 21:50:36', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (14, 3, '修改角色', NULL, 'sys:role:update', NULL, 2, NULL, 2, '2021-01-17 21:51:14', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (15, 3, '删除角色', NULL, 'sys:role:delete', NULL, 2, NULL, 3, '2021-01-17 21:51:39', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (16, 3, '分配权限', NULL, 'sys:role:perm', NULL, 2, NULL, 5, '2021-01-17 21:52:02', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (17, 4, '添加菜单', NULL, 'sys:menu:save', NULL, 2, NULL, 1, '2021-01-17 21:53:53', '2021-01-17 21:55:28', 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (18, 4, '修改菜单', NULL, 'sys:menu:update', NULL, 2, NULL, 2, '2021-01-17 21:56:12', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (19, 4, '删除菜单', NULL, 'sys:menu:delete', NULL, 2, NULL, 3, '2021-01-17 21:56:36', NULL, 1, 0);
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `order_num`, `create_time`, `update_time`, `status`, `is_del`) VALUES (1452877598907482113, 1, '系统日志', 'sys/log', 'sys:log:findList', NULL, 1, NULL, 2, '2021-10-26 13:59:47', NULL, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `code` varchar(64) NOT NULL,
  `remark` varchar(64) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `status` int NOT NULL,
  `is_del` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` (`id`, `name`, `code`, `remark`, `create_time`, `update_time`, `status`, `is_del`) VALUES (3, '普通用户', 'normal', '只有基本查看功能', '2021-01-04 10:09:14', '2021-01-30 08:19:52', 1, NULL);
INSERT INTO `t_role` (`id`, `name`, `code`, `remark`, `create_time`, `update_time`, `status`, `is_del`) VALUES (6, '超级管理员', 'admin', '系统默认最高权限，不可以编辑和任意修改', '2021-01-16 13:29:03', '2021-01-17 15:50:45', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint NOT NULL,
  `menu_id` bigint NOT NULL,
  `is_del` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (96, 3, 1, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (97, 3, 2, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (98, 3, 3, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (99, 3, 4, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (100, 3, 5, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (101, 3, 6, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (118, 6, 1, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (119, 6, 2, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (120, 6, 9, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (121, 6, 10, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (122, 6, 11, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (123, 6, 12, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (124, 6, 13, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (125, 6, 3, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (126, 6, 7, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (127, 6, 14, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (128, 6, 15, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (129, 6, 16, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (130, 6, 4, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (131, 6, 17, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (132, 6, 18, 0);
INSERT INTO `t_role_menu` (`id`, `role_id`, `menu_id`, `is_del`) VALUES (133, 6, 19, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `city` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `status` int NOT NULL,
  `client_id` varchar(64) DEFAULT NULL COMMENT '客户端ID',
  `is_del` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_USERNAME` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `username`, `password`, `avatar`, `email`, `city`, `create_time`, `update_time`, `last_login`, `status`, `client_id`, `is_del`) VALUES (1, 'admin', '$2a$10$R7zegeWzOXPw871CmNuJ6upC0v8D373GuLuTw8jn6NET4BkPRZfgK', 'https://image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/5a9f48118166308daba8b6da7e466aab.jpg', '123@qq.com', '广州', '2021-01-12 22:13:53', '2021-01-16 16:57:32', '2020-12-30 08:38:37', 1, 'ABC', 0);
INSERT INTO `t_user` (`id`, `username`, `password`, `avatar`, `email`, `city`, `create_time`, `update_time`, `last_login`, `status`, `client_id`, `is_del`) VALUES (2, 'test', '$2a$10$glr/BsWsbUIIHfQ988AVQ.gnv2sKN7dyLjXNa9E2JkJgpZJWX/5Ji', 'https://image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/5a9f48118166308daba8b6da7e466aab.jpg', 'test@qq.com', NULL, '2021-01-30 08:20:22', '2021-06-07 10:29:21', NULL, 1, 'ABC', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `is_del` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` (`id`, `user_id`, `role_id`, `is_del`) VALUES (13, 2, 3, 0);
INSERT INTO `t_user_role` (`id`, `user_id`, `role_id`, `is_del`) VALUES (14, 1, 6, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
